Excel stuff:

Heavily comments sample code showing how to:

(1) create an excel spreadsheet from scratch
(2) read an existing excel spreadsheet using early binding
(3) read an existing excel spreadsheet using late binding
(4) create an excel chart from scratch
(5) copy an excel chart onto a VB form

This code barely scratches the surface of how you can use office automation to manipulate excel objects from within a VB application (and of course you can also do all of the same stuff in VBA from within an excel workbook)

Two pieces of advice for learning how to do new things with excel objects.  First, use the object browswer to look for properties and methods and second, use the "record new macro" feature in excel itself to capture the code showing how to do something.

In the comments at the start of the form code, there is a list of a couple of references and components that you need to make sure are in your project for it to work properly.

have fun

Paul Hinds
aka phinds
aka HobbitHouse
